﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using DTO;
namespace DAO
{
    public class NLG_DAO
    {
        public DataProvider _provider = new DataProvider();
        public NLG_DAO()
        {
            _provider.connect();
        }
        public DataTable GetCmbNLG()
        {
            string s = "Select * from NLG";
            return _provider.executeQuery(s);
            
        }
        
        //public DataTable GetDanhSachTP()
        //{
        //    string s = "Select ThanhPham.MaTP,ThanhPham.TenTP,LoaiTP.TenLoaiTP,LoaiTP.MaLoaiTP,ThanhPham.SoLuong, ThanhPham.DVT "
        //                + "from ThanhPham, LoaiTP "
        //                + "where ThanhPham.MaLoaiTP = LoaiTP.MaLoaiTP";

        //    return _provider.executeQuery(s);
        //}
    }
}
